Comparison of Triplestore Architectures in the Oracle RDBMS
نویسنده
چکیده
Several different database configurations for supporting triplestores are implemented in Oracle and compared to each other in terms of execution speed across several queries. The configurations considered are a simple baseline architecture, a Triple-Triple architecture composed of redundant copies of the triples table with different indexing orders, and a configuration based on bitmap join indexes, which are exclusive to the Oracle RDBMS. Sadly, the results for the alternate architectures show no significant improvement over the baseline architecture, seemingly due to inexplicable behavior of Oracle’s internals.
منابع مشابه
ODM BLAST: Sequence Homology Search in the RDBMS
Performing sequence homology searches against DNA or protein sequence databases is an essential bioinformatics task. Past research efforts have been primarily concerned with the development of sensitive and fast sequence homology search algorithms outside of the relational database management system (RDBMS). Oracle Data Mining (ODM) BLAST enables BLAST to be performed in a RDBMS. ODM BLAST reli...
متن کاملDeveloping GeoSPARQL Applications with Oracle Spatial and Graph
Oracle Spatial and Graph – RDF Semantic Graph, an option for Oracle Database 12c, is the only mainstream commercial RDF triplestore that supports the OGC GeoSPARQL standard for spatial data on the Semantic Web. This demonstration will give an overview of the GeoSPARQL implementation in Oracle Spatial and Graph and will show how to load, index and query spatial RDF data. In addition, this demons...
متن کاملCombining high-availability and disaster recovery: Implementing Oracle Maximum Availability Architecture (MAA) on Oracle 10gR2 RDBMS
Increasing dependence of business on 24/7 IT systems sets requirements to support recovery from hardware, software and operational errors and reduce number and length of maintenance windows through online and automated or semi-automated system management activities. These requirements cannot be satisfied purely by technology let alone a single technological innovation on a single layer of a sys...
متن کاملThe Transbase Hypercube RDBMS: Multidimensional Indexing of Relational Tables
Only few multidimensional access methods have made their way into commercial relational DBMS. Even if a RDBMS ships with a multidimensional index, the multidimensional index usually is an add-on like Oracle SDO, which is not integrated into the SQL interpreter, query processor and query optimizer of the DBMS kernel. Our demonstration shows TransBase HyperCube, a commercial RDBMS, whose kernel f...
متن کاملRDF(S) Manipulation, Storage and Querying using Sesame Demo Proposal
Sesame [2] is an RDF framework with support for RDF Schema inferencing. Its main features include querying in three languages (SeRQL, RDQL, RQL), parsing and writing in several serialization syntaxes, support for MySQL, PostgreSQL, Oracle and SQL server as well as in-memory. It can be deployed as an RDF database, with persistence in an RDBMS, or as a Java library for embedded use in application...
متن کامل